# uncompyle6 version 3.2.3
# Python bytecode 3.6 (3379)
# Decompiled from: Python 3.6.8 |Anaconda custom (64-bit)| (default, Feb 21 2019, 18:30:04) [MSC v.1916 64 bit (AMD64)]
# Embedded file name: helpers\sales\db\tables.py
__author__ = "Attila Gerendi (Sanyi)"
from sqlalchemy import *
from sqlalchemy.orm import mapper
from sqlalchemy import MetaData

metadata = MetaData()
OvsEventsTable = Table(
    "ovs_events",
    metadata,
    Column("id", Integer, autoincrement=True, primary_key=True, unique=True),
    Column("timestamp", DateTime, default=func.now()),
    Column("event_type", String(64)),
    Column("user_id", String(64)),
    Column("email", String(100)),
    Column("name", String(100)),
    Column("surname", String(100)),
    Column("country", String(100)),
    Column("company", String(100)),
    Column("phone", String(25)),
    Column("website", String(255)),
    Column("license_key", String(100)),
    Column("scans_total", Integer, default=0),
    Column("scans_network", Integer, default=0),
    Column("scans_network_demo", Integer, default=0),
    Column("scans_web", Integer, default=0),
    Column("scans_web_demo", Integer, default=0),
    Column("source", String(45)),
    Column("registration_address", String(45)),
    Column("activation_address", String(45)),
    Column("request_address", String(45)),
    Column("validated_phone", String(255)),
    Column("verification_counter", Integer, default=0),
)


class OvsEventRow(object):
    id = None

    def __str__(self):
        return "R_ovs_event[%s]" % (self.id,)

    def __repr__(self):
        return self.__str__()


mapper(OvsEventRow, OvsEventsTable)
JitterbitEventsTable = Table(
    "jitterbit_events",
    metadata,
    Column("id", Integer, autoincrement=True, primary_key=True, unique=True),
    Column("event_type", String(64)),
    Column("timestamp", DateTime, default=func.now()),
    Column("user_id", String(64)),
    Column("name", String(100)),
    Column("surname", String(100)),
    Column("country", String(100)),
    Column("company", String(100)),
    Column("phone", String(25)),
    Column("website", String(255)),
    Column("source", String(45)),
)


class JitterbitEventRow(object):
    id = None

    def __str__(self):
        return "R_jitterbit_event[%s]" % (self.id,)

    def __repr__(self):
        return self.__str__()


mapper(JitterbitEventRow, JitterbitEventsTable)
